﻿using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.ComponentModel;
using System.Data;

public class ServiceOrders
{
    DataView _dvServiceOrders;
    public ServiceOrders()
    {
        ////DataSet ds = (DataSet)HttpContext.Current.Cache["ServiceOrderPullAll"];
        //DataTable dt = GetDataTable("SCORE_ServiceOrderPullAll.ORDERS");
        //_dvServiceOrders = dt.DefaultView;
    
    }

    public DataView GetOrders(string psFilter)
    {
        DataTable dt = SQLServer.GetDataTable("SCORE_ServiceOrderPullAll.ORDERS", psFilter);
        _dvServiceOrders = dt.DefaultView;
        _dvServiceOrders.RowFilter = psFilter;
        return _dvServiceOrders;
        //throw new System.NotImplementedException();
    }


}
